package com.dnjn.happiness.biz.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.dnjn.happiness.biz.domain.Checkup;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 体检Mapper接口
 *
 * @author happiness
 * @date 2024-03-27
 */
public interface CheckupMapper extends BaseMapper<Checkup> {

    @Select(" SELECT * FROM biz_checkup WHERE checkup_ref = #{checkupRef} AND deleted = '0' ")
    Checkup selectCheckupByRef(String checkupRef);

    void updateByRef(Checkup dto);

    Page<Checkup> getPage(@Param("page") Page page, @Param("dto") Checkup checkup);
}
